import openpyxl

# 打开工作簿
workbook = openpyxl.load_workbook('data/景区天气.xlsx')
# 选择打开的工作表
sheet = workbook['景区天气']
# 表格数据是一个二维数据，先读取行，再读取列
items = []
for v in sheet.rows:
    sub_items = []
    # 遍历单元格
    for vv in v:
        sub_items.append(vv.value)
    items.append(sub_items)

print(items)
